NthLargest (N, fld), NthLargest (N, fld, condFld), NthLargest (N, fld, condFld, cond)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Determines the Nth largest value in a given field, either for the entire report or for each instance of the (condFld) group.

Examples

The following examples are applicable to both Basic and Crystal syntax:

NthLargest(1, {Customer.CUSTOMER ID}

Returns 50, where the Customer ID field contains numerical values ranging from 12 to 50.

NthLargest(5, {Customer.CUSTOMER NAME}, {Customer.REGION})

Returns the fifth largest value in the Customer Name field, per region.

NthLargest(1, {orders.ORDER AMOUNT}, {Customer.REGION}, "monthly")

Groups values in the Amount field by region, then returns the largest value in the Amount field for each region, per month.

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com